Stable Transaction Management for Preserving the Global Integrity Constraints in Multidatabase Systems

The multidatabase systems(MDBSs) are an integration of local database systems into a global distributed database system. The objectives of global transaction management are to avoid the inconsistent retrievals and to guarantee the global serializability under the existence of indirect conflict which is unknown to the global transaction manager(GTM). Many researches have shown that it is difficult to design the global concurrency control method because of local autonomy. Hence, we adopt the characteristics of global integrity constraints so that inconsistent global schedule can be prohibited and the higher degree of concurrency can be achieved. In this paper, we propose the transaction model for maintaining the global integrity constraints and define the stable global transaction that cannot have any indirect conflict between global transactions. We also propose the optimistic concurrency control method to guarantee the global serializability and logical consistency.